Specify the display order of item properties
- In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
- Click the field whose item properties you want to order.
- On the toolbar in the PivotTable list, click Commands and Options
, and then click the Item Properties tab. The order in which the properties are listed in the Item properties box is the order in which the properties are displayed in the report or ScreenTips.
- Select the property that you want to display at the top, and click Up
until the property appears as the first item in the list. - Order the rest of the properties by clicking Up
or Down
.
Note If new properties are added after you order the list, the new properties will appear at the end of the list until you reorder them.